﻿CREATE TABLE [steve].[UrlRewriteRevision] (
    [UrlRewriteId]         UNIQUEIDENTIFIER NOT NULL,
    [RevisionNumber]       INT              NOT NULL,
    [StartDate]            DATETIME2(7)         NULL,
    [EndDate]              DATETIME2(7)         NULL,
    [IsSecure]             BIT              NOT NULL,
    [RewriteOrder]         INT              NOT NULL,
    [IgnoreQueryString]    BIT              NOT NULL,
    [PassQueryString]      BIT              NOT NULL,
    [SiteUrlId]            UNIQUEIDENTIFIER NOT NULL,
    [RevisionComment]      nVARCHAR (400)    NOT NULL,
    [RevisionDate]         DATETIME2(7)         NOT NULL,
    [RevisionMembershipId] UNIQUEIDENTIFIER NULL
);

